#!/usr/bin/env python
# -*- coding:utf-8 -*-
# @Time : 2022-2-25 14:21
# @Author : huabao.tan
# @File : manning_excel.py
# @Software: PyCharm

from tool.allFunction.Function import *
from tool.excel.excel_tool import *


class CreatPower(CreatExcel):

    def __init__(self):
        # CreatExcel.__init__(self)
        super(CreatPower, self).__init__()

    def creat_excel(self, sum_row):
        row = 0
        while row <= sum_row:
            list_index = [c_name(), creat_Idcard(), education(), college(), rank(), duty(), post(), politics_status()]
            col = 0
            row += 1
            for a in list_index:
                col += 1
                self.sheet_row_col_value(0, row, col, a)
            if row == sum_row:
                break
        self.save_file()


if __name__ == '__main__':
    c = CreatPower()
    c.creat_excel(2000)
